-- ----------------------------- 2023-07-05 add by zhoujq--------------begin

-- 建表语句
CREATE TABLE T_LIMS_PURPOSE( 
    ID NUMBER NOT NULL,
    PURPOSECODE VARCHAR2(100)  NULL,
    PURPOSENAME VARCHAR2(200)  NULL,
    PURPOSETYPE VARCHAR2(100)  NULL,
    DEFAULTRESULT VARCHAR2(200)  NULL,
    RESULTTYPE VARCHAR2(100)  NULL,
    UNIT VARCHAR2(100)  NULL,
    POSSIBLERESULT VARCHAR2(200)  NULL,
    ROUNDINGRULE VARCHAR2(200)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_PURPOSE IS '检测目的';
COMMENT ON COLUMN T_LIMS_PURPOSE.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PURPOSE.PURPOSECODE IS '检测目的编码';
COMMENT ON COLUMN T_LIMS_PURPOSE.PURPOSENAME IS '检测目的';
COMMENT ON COLUMN T_LIMS_PURPOSE.PURPOSETYPE IS '检测目的类别';
COMMENT ON COLUMN T_LIMS_PURPOSE.DEFAULTRESULT IS '默认结果';
COMMENT ON COLUMN T_LIMS_PURPOSE.RESULTTYPE IS '结果类型';
COMMENT ON COLUMN T_LIMS_PURPOSE.UNIT IS '单位';
COMMENT ON COLUMN T_LIMS_PURPOSE.POSSIBLERESULT IS '可选结果';
COMMENT ON COLUMN T_LIMS_PURPOSE.ROUNDINGRULE IS '修约';
COMMENT ON COLUMN T_LIMS_PURPOSE.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PURPOSE.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PURPOSE.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PURPOSE.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PURPOSE.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_PURPOSE ADD CONSTRAINT PK_LIMS_PURPOSE PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSECODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSENAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSETYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','DEFAULTRESULT','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','RESULTTYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','UNIT','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','POSSIBLERESULT','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','ROUNDINGRULE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSECODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSENAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','PURPOSETYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','DEFAULTRESULT','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','RESULTTYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','UNIT','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','POSSIBLERESULT','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','ROUNDINGRULE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_PURPOSE_METHOD( 
    ID NUMBER NOT NULL,
    PURPOSEID NUMBER NULL,
    METHODCODE VARCHAR2(100)  NULL,
    METHODNAME VARCHAR2(200)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL,
    METHODID NUMBER NULL
 );
COMMENT ON TABLE T_LIMS_PURPOSE_METHOD IS '检测目的方法';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.PURPOSEID IS '检测目的id';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.METHODCODE IS '方法编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.METHODNAME IS '方法名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD.METHODID IS '方法id';

ALTER TABLE T_LIMS_PURPOSE_METHOD ADD CONSTRAINT PK_LIMS_PURPOSE_METHOD PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','PURPOSEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODID','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','PURPOSEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','CREATEDBYORGNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD','METHODID','1');
COMMIT;
CREATE TABLE T_LIMS_PURPOSE_METHOD_EQUIPT( 
    ID NUMBER NOT NULL,
    PURPOSEMETHODID NUMBER NULL,
    EQUIPTID NUMBER NULL,
    EQUIPTNAME VARCHAR2(200)  NULL,
    EQUIPTCODE VARCHAR2(200)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_PURPOSE_METHOD_EQUIPT IS '检测目的方法设备表';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.PURPOSEMETHODID IS '方法id';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTID IS '设备id';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTNAME IS '设备名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTCODE IS '设备编号';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_PURPOSE_METHOD_EQUIPT ADD CONSTRAINT PK_LIMS_PURPOSE_METHOD_EQUIPT PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','PURPOSEMETHODID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','PURPOSEMETHODID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','EQUIPTCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_EQUIPT','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_PURPOSE_METHOD_REFER( 
    ID NUMBER NOT NULL,
    PURPOSEMETHODID NUMBER NULL,
    REFERVALUE VARCHAR2(100)  NULL,
    REFERHIGH VARCHAR2(100)  NULL,
    REFERLOW VARCHAR2(100)  NULL,
    DANGERTIP VARCHAR2(200)  NULL,
    REFERTYPE VARCHAR2(50)  NULL,
    DATATYPE VARCHAR2(50)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_PURPOSE_METHOD_REFER IS '参考值危急值表';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.PURPOSEMETHODID IS '检测目的方法id';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.REFERVALUE IS '参考值';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.REFERHIGH IS '高限';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.REFERLOW IS '低限';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.DANGERTIP IS '提示';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.REFERTYPE IS '类型(危急值,参考值)';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.DATATYPE IS '数据类型';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_PURPOSE_METHOD_REFER ADD CONSTRAINT PK_LIMS_PURPOSE_METHOD_REFER PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','PURPOSEMETHODID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERVALUE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERHIGH','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERLOW','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','DANGERTIP','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERTYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','DATATYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','PURPOSEMETHODID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERVALUE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERHIGH','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERLOW','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','DANGERTIP','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','REFERTYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','DATATYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PURPOSE_METHOD_REFER','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_CONDITION_LOT( 
    ID NUMBER NOT NULL,
    LOTCODE VARCHAR2(50)  NULL,
    PRODUCTREFERID NUMBER NULL,
    PRODUCTMETHODID NUMBER NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_CONDITION_LOT IS '条件配置中间表';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.LOTCODE IS '条件批号';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.PRODUCTREFERID IS '参考值危急值ID';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.PRODUCTMETHODID IS '检测项目方法ID';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_CONDITION_LOT.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_CONDITION_LOT ADD CONSTRAINT PK_LIMS_CONDITION_LOT PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','LOTCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','PRODUCTREFERID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','PRODUCTMETHODID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','LOTCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','PRODUCTREFERID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','PRODUCTMETHODID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_CONDITION_LOT','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_PRODUCT_CONDITION( 
    ID NUMBER NOT NULL,
    LOTCODE VARCHAR2(50)  NULL,
    PRODUCTREFERID NUMBER NULL,
    PRODUCTMETHODID NUMBER NULL,
    DATASOURCE VARCHAR2(200)  NULL,
    DATATYPE VARCHAR2(200)  NULL,
    CONDITIONTYPE VARCHAR2(200)  NULL,
    COLUMNNAME VARCHAR2(200)  NULL,
    COLUMNTITLE VARCHAR2(200)  NULL,
    COLUMNVALUE VARCHAR2(200)  NULL,
    COLUMNLOW VARCHAR2(200)  NULL,
    COLUMNHIGH VARCHAR2(200)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_PRODUCT_CONDITION IS '条件配置';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.LOTCODE IS '条件批号';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.PRODUCTREFERID IS '检测项目参考范围ID';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.PRODUCTMETHODID IS '检测项目方法';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.DATASOURCE IS '数据源';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.DATATYPE IS '字段类型';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CONDITIONTYPE IS '条件类型';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.COLUMNNAME IS '字段';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.COLUMNTITLE IS '标题';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.COLUMNVALUE IS '结果';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.COLUMNLOW IS '低限';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.COLUMNHIGH IS '高限';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PRODUCT_CONDITION.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_PRODUCT_CONDITION ADD CONSTRAINT PK_LIMS_PRODUCT_CONDITION PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','LOTCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','PRODUCTREFERID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','PRODUCTMETHODID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','DATASOURCE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','DATATYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CONDITIONTYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNTITLE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNVALUE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNLOW','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNHIGH','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','LOTCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','PRODUCTREFERID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','PRODUCTMETHODID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','DATASOURCE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','DATATYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CONDITIONTYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNTITLE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNVALUE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNLOW','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','COLUMNHIGH','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PRODUCT_CONDITION','CREATEDBYORGNAME','1');
COMMIT;
CALL INSERTI18N('T_LIMS_PURPOSE.SERVICE_NAME', '检测目的', '检测目的', 'zh-CN', '检测目的');
CALL INSERTI18N('T_LIMS_PURPOSE.ID', '检测目的的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PURPOSE.PURPOSECODE', '检测目的的检测目的编码', '检测目的编码', 'zh-CN', '检测目的编码');
CALL INSERTI18N('T_LIMS_PURPOSE.PURPOSENAME', '检测目的的检测目的', '检测目的', 'zh-CN', '检测目的');
CALL INSERTI18N('T_LIMS_PURPOSE.PURPOSETYPE', '检测目的的检测目的类别', '检测目的类别', 'zh-CN', '检测目的类别');
CALL INSERTI18N('T_LIMS_PURPOSE.DEFAULTRESULT', '检测目的的默认结果', '默认结果', 'zh-CN', '默认结果');
CALL INSERTI18N('T_LIMS_PURPOSE.RESULTTYPE', '检测目的的结果类型', '结果类型', 'zh-CN', '结果类型');
CALL INSERTI18N('T_LIMS_PURPOSE.UNIT', '检测目的的单位', '单位', 'zh-CN', '单位');
CALL INSERTI18N('T_LIMS_PURPOSE.POSSIBLERESULT', '检测目的的可选结果', '可选结果', 'zh-CN', '可选结果');
CALL INSERTI18N('T_LIMS_PURPOSE.ROUNDINGRULE', '检测目的的修约', '修约', 'zh-CN', '修约');
CALL INSERTI18N('T_LIMS_PURPOSE.CREATEDBYID', '检测目的的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PURPOSE.CREATEDBYNAME', '检测目的的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PURPOSE.CREATEDTIME', '检测目的的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PURPOSE.CREATEDBYORGID', '检测目的的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PURPOSE.CREATEDBYORGNAME', '检测目的的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.SERVICE_NAME', '检测目的方法', '检测目的方法', 'zh-CN', '检测目的方法');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.ID', '检测目的方法的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.PURPOSEID', '检测目的方法的检测目的id', '检测目的id', 'zh-CN', '检测目的id');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.METHODCODE', '检测目的方法的方法编码', '方法编码', 'zh-CN', '方法编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.METHODNAME', '检测目的方法的方法名称', '方法名称', 'zh-CN', '方法名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.CREATEDBYID', '检测目的方法的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.CREATEDBYNAME', '检测目的方法的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.CREATEDTIME', '检测目的方法的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.CREATEDBYORGID', '检测目的方法的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.CREATEDBYORGNAME', '检测目的方法的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD.METHODID', '检测目的方法的方法id', '方法id', 'zh-CN', '方法id');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.SERVICE_NAME', '检测目的方法设备表', '检测目的方法设备表', 'zh-CN', '检测目的方法设备表');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.ID', '检测目的方法设备表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.PURPOSEMETHODID', '检测目的方法设备表的方法id', '方法id', 'zh-CN', '方法id');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTID', '检测目的方法设备表的设备id', '设备id', 'zh-CN', '设备id');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTNAME', '检测目的方法设备表的设备名称', '设备名称', 'zh-CN', '设备名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.EQUIPTCODE', '检测目的方法设备表的设备编号', '设备编号', 'zh-CN', '设备编号');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYID', '检测目的方法设备表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYNAME', '检测目的方法设备表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDTIME', '检测目的方法设备表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYORGID', '检测目的方法设备表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_EQUIPT.CREATEDBYORGNAME', '检测目的方法设备表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.SERVICE_NAME', '参考值危急值表', '参考值危急值表', 'zh-CN', '参考值危急值表');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.ID', '参考值危急值表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.PURPOSEMETHODID', '参考值危急值表的检测目的方法id', '检测目的方法id', 'zh-CN', '检测目的方法id');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.REFERVALUE', '参考值危急值表的参考值', '参考值', 'zh-CN', '参考值');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.REFERHIGH', '参考值危急值表的高限', '高限', 'zh-CN', '高限');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.REFERLOW', '参考值危急值表的低限', '低限', 'zh-CN', '低限');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.DANGERTIP', '参考值危急值表的提示', '提示', 'zh-CN', '提示');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.REFERTYPE', '参考值危急值表的类型(危急值,参考值)', '类型(危急值,参考值)', 'zh-CN', '类型(危急值,参考值)');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.DATATYPE', '参考值危急值表的数据类型', '数据类型', 'zh-CN', '数据类型');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYID', '参考值危急值表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYNAME', '参考值危急值表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.CREATEDTIME', '参考值危急值表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYORGID', '参考值危急值表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PURPOSE_METHOD_REFER.CREATEDBYORGNAME', '参考值危急值表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.SERVICE_NAME', '条件配置中间表', '条件配置中间表', 'zh-CN', '条件配置中间表');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.ID', '条件配置中间表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.LOTCODE', '条件配置中间表的条件批号', '条件批号', 'zh-CN', '条件批号');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.PRODUCTREFERID', '条件配置中间表的参考值危急值ID', '参考值危急值ID', 'zh-CN', '参考值危急值ID');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.PRODUCTMETHODID', '条件配置中间表的检测项目方法ID', '检测项目方法ID', 'zh-CN', '检测项目方法ID');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.CREATEDBYID', '条件配置中间表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.CREATEDBYNAME', '条件配置中间表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.CREATEDTIME', '条件配置中间表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.CREATEDBYORGID', '条件配置中间表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_CONDITION_LOT.CREATEDBYORGNAME', '条件配置中间表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.SERVICE_NAME', '条件配置', '条件配置', 'zh-CN', '条件配置');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.ID', '条件配置的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.LOTCODE', '条件配置的条件批号', '条件批号', 'zh-CN', '条件批号');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.PRODUCTREFERID', '条件配置的检测项目参考范围ID', '检测项目参考范围ID', 'zh-CN', '检测项目参考范围ID');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.PRODUCTMETHODID', '条件配置的检测项目方法', '检测项目方法', 'zh-CN', '检测项目方法');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.DATASOURCE', '条件配置的数据源', '数据源', 'zh-CN', '数据源');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.DATATYPE', '条件配置的字段类型', '字段类型', 'zh-CN', '字段类型');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CONDITIONTYPE', '条件配置的条件类型', '条件类型', 'zh-CN', '条件类型');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.COLUMNNAME', '条件配置的字段', '字段', 'zh-CN', '字段');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.COLUMNTITLE', '条件配置的标题', '标题', 'zh-CN', '标题');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.COLUMNVALUE', '条件配置的结果', '结果', 'zh-CN', '结果');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.COLUMNLOW', '条件配置的低限', '低限', 'zh-CN', '低限');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.COLUMNHIGH', '条件配置的高限', '高限', 'zh-CN', '高限');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CREATEDBYID', '条件配置的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CREATEDBYNAME', '条件配置的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CREATEDTIME', '条件配置的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CREATEDBYORGID', '条件配置的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PRODUCT_CONDITION.CREATEDBYORGNAME', '条件配置的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.COREDATA.PJPRODUCTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.COREDATA.PJPRODUCTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.COREDATA.PJPRODUCTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.COREDATA.PJPRODUCTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.COREDATA.PJPRODUCTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('2023070501', '普检检测目的', '/secure/basemodule/coredata/purpose-method-equipts/page/edit-list', 'null', '2023070501', 'null', '普检检测目的');

INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PURPOSE', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PURPOSE_METHOD', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PURPOSE_METHOD_EQUIPT', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PURPOSE_METHOD_REFER', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_CONDITION_LOT', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PRODUCT_CONDITION', '0', '0');


COMMIT;

-- ----------------------------- 2023-07-05 add by zhoujq------------end